﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using ExtAspNet;
using System.Text;

namespace HY.WEB.PQ
{
    public partial class _ht_comp : PageBase
    {

        public string stype = "";
        public string us, um, bh, ro;
        public string tab = "comp_ht";
        public string whe = "", whe2 = "", whe3 = "", whe4 = "";
        public string ubh;

        public int pgCount = 0;

        protected void Page_Load(object sender, EventArgs e)
        {

            us = Session["ID"].ToString();
            um = Session["user"].ToString();
            ubh = Session["bh"].ToString();
            um = Session["user"].ToString();
            ro = Session["role"].ToString();

            //whe = " cbh in (select cbh from company_fav where sbh='" + bh + "')";
            whe = "";
            //取组名

            string gnm = BLL.Bllbase.check_rol(ubh);
            if (gnm != "" & ro != "系统管理员")
            {
               // whe3 = " and pbh in (select cbh from company_fav where sbh in(select sbh from sys_user where dgroup=''" + gnm + "'' ))";
                whe4 = " and pbh in (select cbh from company_fav where sbh in(select sbh from sys_user where dgroup='" + gnm + "' ))";
            }
            if (gnm == "" & ro != "系统管理员")
            {
                whe4 = " and pbh='" + ubh + "' or sbh='" + ubh + "'";
            }


            if (!IsPostBack)
            {
               
                btnDelete.OnClientClick = Grid1.GetNoSelectionAlertReference("至少选择一项！");
                btnNew.OnClientClick = Window1.GetSaveStateReference(hidstype.ClientID)
                                       +Window1.GetShowReference("ht_comp_add.aspx?stype=" + stype + "", "新增");
                btnSearch.OnClientClick = Window1.GetShowReference("../function/search.aspx?tab=" + tab + "", "高级搜索");
      
                BindGrid();
                fill(); //填充查询
                
            }

        }
        public string getht(string txt)
        {
            string val = "";
            if (txt == "company") val = "企业";
            if (txt == "school") val = "学校";
            if (txt == "zj") val = "中介";

            return val;

        }
          private void fill()
          {
              DataTable d = BLL.BLLfun.get_search(tab);
             for (int i = 0; i < d.Rows.Count; i++)
                    {
                        ddlfiled.Items.Add(new ExtAspNet.ListItem(d.Rows[i][1].ToString(), d.Rows[i][0].ToString()));
                    }
               ddlfiled.DataBind();

               DataTable e = BLL.BLLfun.get_where();
               for (int i = 0; i < e.Rows.Count; i++)
               {
                   ddlwhere.Items.Add(new ExtAspNet.ListItem(e.Rows[i][0].ToString(), e.Rows[i][1].ToString()));
               }
               ddlwhere.DataBind();

            
        }

        private void BindGrid()
        {
            BLL.PQ.comp_ht j = new BLL.PQ.comp_ht();

            DataTable table = BLL.Bllbase.get_table(tab,whe+whe4);
           
            Grid1.DataSource = table;
            Grid1.DataBind();

        }

        protected void Grid1_PageIndexChange(object sender, ExtAspNet.GridPageEventArgs e)
        {
            Grid1.PageIndex = e.NewPageIndex;
        }



        protected void Grid1_Sort(object sender, ExtAspNet.GridSortEventArgs e)
        {


           // BLL.PQ.pq_ht j = new BLL.PQ.pq_ht();


            DataTable table = BLL.Bllbase.get_table(tab, whe+whe4); 


            //if (whe != "")
            //    table = j.GetList(whe).Tables[0];
            //else
            //    table = j.GetAllList().Tables[0];



            DataView view1 = table.DefaultView;
            view1.Sort = String.Format("{0} {1}", e.SortField, e.SortDirection);

            Grid1.DataSource = view1;
            Grid1.DataBind();
        }

 


        #region Events

        protected void btnDelete_Click(object sender, EventArgs e)
        {
            int val = Grid1.PageIndex * Grid1.PageSize;

            string sy="",sc = "";
            StringBuilder sb = new StringBuilder();
            foreach (int row in Grid1.SelectedRowIndexArray)
            {
                sb.Append(Grid1.DataKeys[row + val][0].ToString());
              
                sy = Grid1.DataKeys[row + val][1].ToString();
                sc = Grid1.DataKeys[row + val][2].ToString();

                BLL.BLLfun.up_sales_num_del(sy, sc); //减少到企业签约次数
               
                sb.Append(",");

            }

            Alert.ShowInTop("你选择了删除项：" + sb.ToString().TrimEnd(','));
            HY.BLL.Bllbase.DeleteList(tab, sb.ToString().TrimEnd(','));
          
            BindGrid();


        }


        protected void Window1_Close(object sender, EventArgs e)
        {
            // Alert.ShowInTop("弹出窗口关闭了！");
              string key = txt.Text.Trim();
              stype = hidstype.Text;
              try
              {
                  if (key == "") whe = BLL.pub.pubwhere.get_where_sql(us, tab);
                  BindGrid();

              }catch(Exception ex)
              {
                  Alert.Show("查询条件错误");
              }
              finally
              {
                  whe = "";
              }
        }

        #endregion
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ttbSearchMessage_Trigger2Click(object sender, EventArgs e)
        {
            txt.ShowTrigger1 = true;
            string ddlf = ddlfiled.SelectedValue;
            string ddlw = ddlwhere.SelectedValue;
            string key = txt.Text.Trim();
            if (ddlw.Equals("="))
                whe = "" + ddlf + " like  '%" + key + "%'";
            else
            {
              if (ddlf=="sid"||ddlf=="编号") 
                  whe = "" + ddlf + " " + ddlw + " " + key + "";
              else
                  whe = "" + ddlf + " " + ddlw + " '" + key + "'";

            }
            if (key == "") whe = "";

            BindGrid();
        }

        /// <summary>
        /// 清除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ttbSearchMessage_Trigger1Click(object sender, EventArgs e)
        {
            txt.Text = String.Empty;
            txt.ShowTrigger1 = false;
            BindGrid();
        }

      
    

        }




    
}